<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<html dir="ltr" xml:lang="en-gb" xmlns="http://www.w3.org/1999/xhtml"
	lang="en-gb">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta name="robots" content="index, follow">
<meta name="keywords" content="joomla, Joomla">
<meta name="description"
	content="Joomla! - the dynamic portal engine and content management system">
<meta name="generator"
	content="Joomla! 1.5 - Open Source Content Management">
<title>Welcome to the Mountain View Community Hospital</title>
<link rel="stylesheet" href="../image/template.css" type="text/css">
<link rel="stylesheet" href="../image/constant.css" type="text/css">

<!--equal-->
<!--[if IE]>
   <script type="text/javascript" src="/joomla_24417/templates/theme288/scripts/ie_png.js"></script>
   <script type="text/javascript">
       ie_png.fix('.png');
	</script>
<![endif]-->
</head>
<sql:setDataSource var="datas" driver="oracle.jdbc.driver.OracleDriver"
     url="jdbc:oracle:thin:@localhost:1521:orcl"
     user="dbfp_dba"  password="dbfpdba"/>

<sql:query dataSource="${datas}" var="resultSet" sql="SELECT * FROM drug_t"/>
<body id="body">
	<!--header-->
	<div class="tail-logo">
		<div class="tail-right"></div>
		<div class="main">
			<div class="row-logo">
				<h1 style="font-size: 30px; color: white;">Mountain View
					Community Hospital</h1>
			</div>
		</div>
	</div>
	<div class="tail-header">
		<div class="main">
			<div class="header">
				<div class="fright">
					<div class="row-1">
						<div class="moduletable">
							<img src="../image/header_link_img_1.gif" alt=""> <img
								src="../image/header_link_img_2.gif" alt=""> <img
								src="../image/header_link_img_3.gif" alt=""> <img
								src="../image/header_link_img_4.gif" alt=""> <img
								src="../image/header_link_img_5.gif" alt="">
						</div>
					</div>

				</div>

				<div class="clear1"></div>
			</div>
		</div>
	</div>
	<div class="tail-row-top-menu clear">
		<div class="main">
			<div class="row-top-menu clear">
				<div class="fright">
					<div class="module" style="text-align: right; margin-top: 15px;">
						<h4>${accountID},${role},${personID}<a href="/project/resources/common/login.htm">Logout</a></h4>


					</div>

				</div>
				<div class="fleft">
					<div class="module-search"></div>
				</div>
			</div>
		</div>
	</div>
	<div class="main">
		<div class="clear wrapper-box module-login">
			<div class="box-title" style="height: 50px">
				<div class="bull-title png" style="width: 500px; float: left;">
					<h3>Drug</h3>
				</div>
				<div class="bull-title png" style="float: right; margin-top: 15px">
					<input name="Submit" class="button png" value="Back" type="submit">
				</div>
			</div>
			<div class="box-indent">
				<div class="clear">

					<div>
						<table style="background-color: white; width: 900px;"
							borderColor="#aaaaaa" cellspacing="25" cellpadding="5"
							bgcolor="#eeeeee" border="10">
							<tr>
								<th style="width: 100px; ">Drug ID</th>
								<th style="width: 100px; ">Price</th>
							    <th style="width: 100px; ">Description</th>
							    <th style="width: 100px; ">Quantity</th>
							    
							</tr>
							<c:forEach var="report" items="${resultSet.rows }">
							<tr>
								<td>${report.drug_id}</td>
								<td>${report.price}</td>
								<td>${report.description}</td>
								<td>${report.quantity}</td>
								
								
							</tr>
						
							</c:forEach>
						</table>
					</div>
				</div>
			</div>

		</div>
</body>
</html>
